Stored Procedures [dbo].[BAEImisGetProduct]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@productCodevarchar(31)31
SQL Script
create procedure [dbo].[BAEImisGetProduct] @productCode varchar(31) as
SELECT * FROM Product WHERE PRODUCT_CODE = @productCode

GO
Uses